#1
|
|||
|
|||
Rows to Columns
I have the a big excel file, and I need to convert the last column from columns to rows. but the grouping by Emp NO should be maintained. please see the screenshot any ides please?? |
#2
|
|||
|
|||
Hi,
could you please provide a short example picture of how you would like the result to look like? Kind regards Bjorn |
#3
|
|||
|
|||
thanks for your reply.
the result should be something like the attached. I know about the transpose paste special, but the problem its not maintaining the grouping by Emp NO. |
#4
|
|||
|
|||
Hi,
I have only a few minutes before I leave, therefor you get a short explanation to a solution. First: Make a backup of your sheet, then mark all your data and take away the concatination (at all cells). Insert one row at the top. Copy the cells I1:AA3 in the attachment and paste it into the same cells in your sheet. Mark the complete columns K:L and name this area "Data" Mark cells I3:AA3. Copy these cells down as far as you have data. Now the columns M:AA should contain your wanted result. If you have more than 15 competences per employee (check max of column J to see this), you must extend the columns further to the right of AA. Now mark all cells in the columns I1:AA9999 (as many lines you have). Copy... Paste special... values. Delete the columns H:L. Done! Please don't hesitate to ask question. I hope a got the explanation right Must hurry! Kind regards Bjorn |
#5
|
|||
|
|||
thank you man!!!
its working fine. you are an expert... |
#6
|
|||
|
|||
Hi,
I am happy that it worked as you wanted Please mark the issue as solved. Kind regards Bjorn |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Odd behaviour of table - keep rows together | Stephan Lindner | Word Tables | 1 | 09-10-2011 05:31 AM |
Average of many rows | speedycorn1 | Excel | 1 | 10-30-2010 07:54 PM |
How to compare 2 columns with other two columns in EXECL 2007? | Learner7 | Excel | 5 | 06-12-2010 09:54 AM |
How do I turn the top 2 rows into a header | GR8Fandini | Excel | 1 | 02-06-2010 12:58 PM |
Conditional Formatting to Hide Rows or Columns? | sczegus | Excel | 0 | 09-26-2006 04:17 PM |