Forum Discussion
MasonF2265
May 19, 2021Copper Contributor
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...
- May 19, 2021
Cities is the name of this entire structured table
Do you use range or table? Just in case attached is the latest file.
MasonF2265
May 19, 2021Copper Contributor
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?
SergeiBaklan
May 19, 2021Diamond Contributor
Cities is the name of this entire structured table
Do you use range or table? Just in case attached is the latest file.
- MasonF2265May 19, 2021Copper ContributorHi,
I was FINALLY able to input the formula and have it work correctly! Thank you so so so much!- SergeiBaklanMay 19, 2021Diamond Contributor
MasonF2265 , you are welcome