I would like to find a way to copy the data from my pivot table into empty cells. For each MHxxxxx field I want the corresponding top 3 fields copied into cells. For example:
MH81711 has three sub fields: Russell, 142.16.193.8, 10th st. I would like to have MH81711 copied into A1, Russell into B1, 142.16.193.8 into C1, 10th into D1. Then loop through and find all the rest in the pivot table and copy into the next row. The number of fields are variable and there will not always be 3 for each MHxxxxx.
Is this possible? I have included a screen shot of what my pivot table looks like. The 142.16.193.8 number will be converted to text in the future, consider it a string like the other two.
pivot.png
If the output can be like this:
output.png
If someone has an idea or suggestion I'm all ears. Thank you very much for any help you can provide.
Bookmarks