amitvnarendra
New Member
- Joined
- Dec 19, 2008
- Messages
- 30
Hello,
I have an excel file where the top row consists of dates (182 data points) and then I have column A which consists of city names (90 city names).
Now I want to transpose dates in column and then I want to paste cities next to the dates. Eg: so for the 182 dates data point I want to paste city A next to all the data points. Then I want to paste again those 182 data point and next to it paste city B, and so on until I paste all the 90 cities.
Is there a quick way of performing this task?
Any help on this will be highly appreciated.
Kind regards,
Amit Narendra
I have an excel file where the top row consists of dates (182 data points) and then I have column A which consists of city names (90 city names).
Now I want to transpose dates in column and then I want to paste cities next to the dates. Eg: so for the 182 dates data point I want to paste city A next to all the data points. Then I want to paste again those 182 data point and next to it paste city B, and so on until I paste all the 90 cities.
Is there a quick way of performing this task?
Any help on this will be highly appreciated.
Kind regards,
Amit Narendra