Prev Previous Post   Next Post Next
  #1   Report Post  
RColeII
 
Posts: n/a
Default Columns to Rows

I need to take a worksheet with columns A1, B1, C1, D1 and reformat those
into rows.

The end result should be:

C-A1
C-B1
C-C1
C-D1
C-A2
C-B2
C-C2
C-D2
etc.

Suggestions?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hidden rows & columns slow file open Simon Shaw Excel Discussion (Misc queries) 0 April 5th 05 12:21 AM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM
Converting Columns to Rows Chris D'Onofrio Excel Worksheet Functions 1 March 30th 05 08:08 PM
How do I lookup values from rows and columns Simultaneously PK Excel Worksheet Functions 2 March 29th 05 04:34 PM
Can I split my worksheet and have different size columns and rows. tommy Excel Discussion (Misc queries) 1 February 16th 05 11:17 PM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"