Dear All,
Please I have been trying to convert the excel data attached from horizontal to vertical. As you can see, the six years are spread horizontally but I want to have only one column per time per with six years rows. Any help will be much appreciated.
Thanks
Godfred
Hi
Please take a look at the attached file.
Is this what are you looking for?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi Godfred,
I wrote come code a while back that does what you want.
See it in the attached. Your original data is on Sheet 2 and the converted data is on Sheet1.
I needed to attach the file that is in 2007/2010 format as it compresses your .xls file. The .xls was too big to attach.
Here is the Code I used to convert the CrossTab to a normal table.
I ran the above code from the immediate window using:
Please Login or Register to view this content.
because you had only 1 Column (Column A) that was repeated.Please Login or Register to view this content.
I hope you can run the code on your .xls or have a newer version of Excel to use the Attached.
BTW - Change the word "Date" in B1 to a more appropriate column title.
Last edited by MarvinP; 11-06-2011 at 10:15 AM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Is it possible to give model of result required in other sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks