It must be easy!

pleasehelpme · Apr 23rd, 2002, 07:20 AM

I have got lots of data in about 12 columns. I am looking for a way to automatically get this information into one column. For example:

If I had this data:

A B C D
3 9 5
3 2 7 7
9 4 1
8
I would like column E to read:

3
3
9
2
4
9
7
5
7
1
8

Is there an easy way of doing this automatically, cause there is lots of data?
Thanks,
Nick

KniteMare · Apr 23rd, 2002, 07:26 AM

Please specify your logical sequence for formatting your data. At a quick glance Your column makes no sense.

Also is this a one time event or something you need to have done with relitive frequency?

How large are the columns, How wide the rows.

In other words you need to give more information.
Yours in EXCELent Frustration
KniteMare

pleasehelpme · Apr 23rd, 2002, 07:32 AM

Sorry,

I put in spaces and they have not shown up.
OK hopefully this will be better:

"A","B"
"3",""
"2","4"
"1","9"
"8",""

I would like column C to read:

3
2
1
8
4
9

Sorry about that,
Nick

gareth · Apr 23rd, 2002, 07:40 AM

Have you heard of the link called ASAP Utilities my friend.If you have not please E-Mail me and i will give you the details.

Apr 23rd, 2002, 07:40 AM	#4
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Have you heard of the link called ASAP Utilities my friend.If you have not please E-Mail me and i will give you the details. __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 07:20 AM	#1
pleasehelpme New Member Join Date: Apr 2002 Posts: 5	I have got lots of data in about 12 columns. I am looking for a way to automatically get this information into one column. For example: If I had this data: A B C D 3 9 5 3 2 7 7 9 4 1 8 I would like column E to read: 3 3 9 2 4 9 7 5 7 1 8 Is there an easy way of doing this automatically, cause there is lots of data? Thanks, Nick

Apr 23rd, 2002, 07:26 AM	#2
KniteMare Board Regular Join Date: Mar 2002 Location: Hilo, Hawaii Posts: 240	Please specify your logical sequence for formatting your data. At a quick glance Your column makes no sense. Also is this a one time event or something you need to have done with relitive frequency? How large are the columns, How wide the rows. In other words you need to give more information. Yours in EXCELent Frustration KniteMare

Apr 23rd, 2002, 07:32 AM	#3
pleasehelpme New Member Join Date: Apr 2002 Posts: 5	Sorry, I put in spaces and they have not shown up. OK hopefully this will be better: "A","B" "3","" "2","4" "1","9" "8","" I would like column C to read: 3 2 1 8 4 9 Sorry about that, Nick