sorting data
if I have my data sorted in the form:
coloumn1 coloumn2 coloumn3 coloumn 4
variable series year1 year2
x 1
x 2
x 3
y 1
y 2
y 3
how can i convert this into this form:
coloumn1 coloumn2 coloumn3 coloumn4
series year x y
1 year1
1 year2
1 year3
2 year1
2 year2
2 year3
Hi and welcome to the forum
It's not always easy to understand from narrative text where the column delimiters are.
No doubt if you upload an example workbook showing the data beforehand, and manually add the results you expect in another range, we'll be able to offer a solution.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard, thanks for your reply,
this was what I am trying to figure out, to sort the table on the left into the format on the right? any advice?
20160119_183332.jpg
problem is I have a lot of data points, so sorting it manually becomes almost impossible!
Hi,
Would you upload the workbook as requested. Pictures are rarely much use since not many of us want to spend time re-creating data you already have to hand.
Aid stuff.xlsx
Hi, thanks for the reply. I have attached the document. Sheet 1 has the data I am trying to transform, sheet 2 gives a depiction of what I am trying to achieve
I can't help thinking your analysis would be simplified if your data was held in a normalised 2 dimensional table with just four columns
Series Name
Country Name
Year
Value
With this layout then a Pivot Table will allow as much analysis and summarisation that you might ever need. Are you able to capture the data in this layout?
Even if you can't I'd still be inclined to have a pre-processing macro that could take your Sheet1 data and put it into the four column layout.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks