Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-05-2010, 11:31 PM
kyakobi kyakobi is offline Rows to Columns Windows XP Rows to Columns Office 2003
Novice
Rows to Columns
 
Join Date: Dec 2010
Posts: 3
kyakobi is on a distinguished road
Default 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??
Attached Images
File Type: jpg Excel.jpg (64.2 KB, 29 views)
Reply With Quote
  #2  
Old 12-06-2010, 07:11 AM
BjornS BjornS is offline Rows to Columns Windows Vista Rows to Columns Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
could you please provide a short example picture of how you would like the result to look like?

Kind regards
Bjorn
Reply With Quote
  #3  
Old 12-06-2010, 10:10 AM
kyakobi kyakobi is offline Rows to Columns Windows XP Rows to Columns Office 2003
Novice
Rows to Columns
 
Join Date: Dec 2010
Posts: 3
kyakobi is on a distinguished road
Default

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.
Attached Images
File Type: jpg example.jpg (27.2 KB, 22 views)
Reply With Quote
  #4  
Old 12-07-2010, 12:12 AM
BjornS BjornS is offline Rows to Columns Windows Vista Rows to Columns Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

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
Attached Files
File Type: xls Transpose_special.xls (33.5 KB, 19 views)
Reply With Quote
  #5  
Old 12-07-2010, 03:18 AM
kyakobi kyakobi is offline Rows to Columns Windows XP Rows to Columns Office 2003
Novice
Rows to Columns
 
Join Date: Dec 2010
Posts: 3
kyakobi is on a distinguished road
Default

thank you man!!!

its working fine. you are an expert...
Reply With Quote
  #6  
Old 12-07-2010, 03:12 PM
BjornS BjornS is offline Rows to Columns Windows Vista Rows to Columns Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
I am happy that it worked as you wanted
Please mark the issue as solved.

Kind regards
Bjorn
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rows to Columns Odd behaviour of table - keep rows together Stephan Lindner Word Tables 1 09-10-2011 05:31 AM
Rows to Columns Average of many rows speedycorn1 Excel 1 10-30-2010 07:54 PM
Rows to Columns How to compare 2 columns with other two columns in EXECL 2007? Learner7 Excel 5 06-12-2010 09:54 AM
Rows to Columns 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft