pivoting data

mroker · February 8

Hi, I have data in this format:

Date Island Count

2021-01-02 Aruba 4

2021-02-01 Curacao 9

2021-03-01 Curacao 10

I would like the data to be formatted this way:

Island 2021-01-02 2021-02-01

Aruba 4 7

Curacao 9 10

This format is for a table view

ColemenWilson · February 8

You'll get the format you want with a pivot card if you set it up as shown below:

Would these results work for you? If not you can use the table card and click "transpose" in General Chart Properties but I don't think that gets you the format you are looking for:

But if so you can use the table card and click "transpose" in General Chart Properties

MichelleH · February 8

@mroker I'd suggest using a pivot table chart with Island in the rows, Date in the columns, and Count in the values

mroker · February 8

Yes, I tried this, but not getting the results that I would have hoped for.

MichelleH · February 8

@mroker Can you please show what the results look like?

ColemenWilson · February 8

You'll get the format you want with a pivot card if you set it up as shown below:

Would these results work for you? If not you can use the table card and click "transpose" in General Chart Properties but I don't think that gets you the format you are looking for:

But if so you can use the table card and click "transpose" in General Chart Properties

pivoting data

Best Answer

Answers

Categories