Hello Excel Experts,
I need to figure out a way to transpose several columns in 2 columns. The big hangup for me is the Address column (see link to Google sheet below. The value in the group in the Address column now only appears once, but it will need to be repeated in the desired layout.
Link to Sheet: https://docs.google.com/spreadsheets...it?usp=sharing
I'm not sure about whether there is a function that can be worked out or if I need VBA.
All feedback would be greatly appreciated.
Thanks!
Bookmarks