LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default How to separate variables within a column

Hi

I need help. I have want to separate one column into two. But I don't want
to sort or filter, I want to make two extra columns, so I can view the data
side by side, how do I do it?

eg
make

A 2 x
A 2 y
B 2 x
B 2 y

into
x y
A 2 2
B 2 2



 
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
COUNTIF formula with several variables in 1 column NitaMax Excel Discussion (Misc queries) 3 February 8th 07 02:35 AM
How to one cells variables as a serie to a column noyau New Users to Excel 6 December 22nd 06 10:58 AM
Counting values for variables in separate columns MMcQ Excel Discussion (Misc queries) 6 August 30th 06 12:28 PM
How do I sort a column of computed variables in EXCEL? Sylgeox Excel Worksheet Functions 2 October 3rd 05 12:07 AM
column variables mahmon Excel Worksheet Functions 19 June 27th 05 08:53 PM


All times are GMT +1. The time now is 05:21 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"