Using VBA to rearrange data

A

arothacker

Joined
Apr 13, 2012
Messages
8
Reaction score
0
[FONT=&quot]Hi there-

The data I'm working with is exported from an online system and comes in the following format:
[/FONT]
Account AAAA Desc 1111
XXXXXX1 XXXX1 XX1 XXX1
XXXXXX1 XXXX1 XX1 XXX1
Account BBBB Desc 2222
XXXXXX1 XXXX1 XX1 XXX1
XXXXXX1 XXXX1 XX1 XXX1
XXXXXX1 XXXX1 XX1 XXX1

What I need it to look like is this:

AAAA 1111 XXXXXX1 XXXX1 XX1 XXX1
AAAA 1111 XXXXXX1 XXXX1 XX1 XXX1
BBBB 2222 XXXXXX1 XXXX1 XX1 XXX1
BBBB 2222 XXXXXX1 XXXX1 XX1 XXX1
BBBB 2222 XXXXXX1 XXXX1 XX1 XXX1

[FONT=&quot]
[FONT=&quot]I'm hoping to use a vba code to do this but I don't have too much experience with writing them. Also the number of rows between the accounts won't necessarily be the same every time.
[/FONT][FONT=&quot]
Please help if you can!!!!!

-Ashley[/FONT][/FONT]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filling in some blanks to a data table 3
Excel 2003: Copy rows from one workbook into another without losinginterleaved data 3
Using COUNTU in VBA to delete certain values 2
Access Export of data to Excel using VBA - data looks awful 4
using excel data to create multiple web pages 1
Mail Merge from vba Outlook using Word Template 0
Using VBA to swap between a clustered or separated column chart 4
Macro to clean up data 8

Top