Forum Discussion
Convert a two line address to individual columns?
I'm not a mac user, but with pivot it would be best. Here is an example of where you can make changes yourself.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
I'm not a mac user, but with pivot it would be best. Here is an example of where you can make changes yourself.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
ECJ53 I'm not sure how that pivot table solves what you wanted but in the attached I added a column (address 2) that just points to the row 1 down in the address column. Then with some slight format fixes of the pivot table I think you will now get what you want. OR I inserted another sheet and using 2 formulas re-created that table without the mostly blank lines (1 formula to recreate the header line and 1 formula with a Filter() function).
Hope this helps.