Forum Discussion
Solved
Pivot Table but Transpose values
Hi everyone, I am trying to figure out a formula/way to quickly transpose all city values from rows to columns for each ID number. As you can tell from below, some ID numbers have multiple citie...
Cities is the name of this entire structured table
Do you use range or table? Just in case attached is the latest file.
In your old school formulas, I see you have =IFERROR(INDEX(Cities[ID number], AGGREGATE(15,6,1/(COUNTIF($L$4:L5, Cities[ID number])=0)*ROW(Cities[ID number]),1)-ROW(Cities[[#Headers],[ID number]])),"")
When I put this in, it says there is a problem with my formula and points back to the "Cities" you included here. Looking at the spreadsheet you provided, I can only see "City" which is in D3. Are you renaming something or where is the "Cities" part coming in from?
When I put this in, it says there is a problem with my formula and points back to the "Cities" you included here. Looking at the spreadsheet you provided, I can only see "City" which is in D3. Are you renaming something or where is the "Cities" part coming in from?
Cities is the name of this entire structured table
Do you use range or table? Just in case attached is the latest file.
- Hi,
I was FINALLY able to input the formula and have it work correctly! Thank you so so so much!MasonF2265 , you are welcome