×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Convert row to column

Convert row to column

Convert row to column

(OP)
I have an excel spreadsheet as follows

123456 abc def
123456. Xyz Mano
7890 Tyu iOS
7890. Min opu
7890 Ire xyz
6789. Abc
5678. Mano


So i need a script which will do the following

Should check the first column and if the numbers are repeated the remaining two columns should be like this if not leave it as it is

123456 abc def xyz Mano
7890. Tyu iOS Min opu ire xyz
6789. abc
5678. Mano

RE: Convert row to column

Hi,

123456 abc def xyz Mano
7890.  Tyu iOS Min opu  ire xyz
 

Why does the PERIOD appear after 7890, but not after 123456?

BTW, I can remember doing stuff like this on a spreadsheet with formulas back in the '90s. As a programmer, you ought to be able to figure this one out pretty easy.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Convert row to column

Well, I was bored so I did most of it in the attached table, except for the coup de grĂ¢ce.

Results...
123456	abc 	def	Xyz 	Mano		
123456	Xyz 	Mano				
7890	Tyu 	iOS	Min 	opu	Ire 	xyz
7890	Min 	opu	Ire 	xyz		
7890	Ire 	xyz				
6789	Abc					
5678	Mano					
 


Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Convert row to column

(OP)
Hi skip - thanks why I am not able to see the macro or formula that you suggested?

RE: Convert row to column

I uploaded a file.

But here's the formula in D1

D1: =IF($A2=$A1,B2,"")

Propagate across as needed and down thru all rows.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Convert row to column

(OP)
I forgot to mention one thing the number of rows is large like 1000 + rows hence wanted a macro



RE: Convert row to column

You think 1000 rows is large for using formulas?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close