Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ah 3
 
Posts: n/a
Default how to convert multiple columns of data into one single column?

as subject, e.g.

from...

A B C D
Mary Peter Paul David
John Nancy Lucy Ken
Alice Annie Danny Jane

to...

A
Mary
John
Alice
Peter
Nancy
Annie
Paul
Lucy
Danny
David
Ken
Jane

Many thanks!
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"Ah 3" schrieb im Newsbeitrag
...
as subject, e.g.

from...

A B C D
Mary Peter Paul David
John Nancy Lucy Ken
Alice Annie Danny Jane

to...

A
Mary
John
Alice
Peter
Nancy
Annie
Paul
Lucy
Danny
David
Ken
Jane

Many thanks!


Reply
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
How do I link columns so data flows from 1 column to another like. M. Frazel Excel Discussion (Misc queries) 1 January 14th 05 05:17 PM
Pivot Table combining multiple columns Pete Petersen Excel Discussion (Misc queries) 1 January 13th 05 08:56 PM
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 07:00 PM
how do I easily convert a single column of text (multiple rows si. philmah Excel Discussion (Misc queries) 2 December 16th 04 01:24 AM
Drop-down selection fills data across multiple columns Tom Excel Discussion (Misc queries) 7 December 2nd 04 01:43 AM


All times are GMT +1. The time now is 11:34 PM.

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

About Us

"It's about Microsoft Excel"