Sort data of addresses into Table

General Web Dev
1

Hi,

I have extracted client information I obtain and the information is presented in a massive list, row by row. I have over 300 names, addresses and phone numbers and what I’m looking to do is compile the information into a more organized table in Excel to begin with so that it’s setup right for a process in the future with Outlook and Access.

I have the list on Excel all in the one coloum
NAME
NUMBER
ADDRESS
NAME
NUMBER
ADDRESS
ETC

I’d like to get the information into separate coloums of Name, Address, Number in a table like fashion.

But how could I possibly do that?

A very long winded way would be to sit and hit CTRL and click all the names then copy. But Excell is very fishy when it comes to multiple selections.

Any tips?

Thanks!

1 Like
2

Anybody any ideas please?

Thanks

3

Not sure how this relates to web development @Albablue89?

4

So after you have organized the spreadsheet into columns, are you going to want to import it into your Access database? There are all sorts of instructions on how to perform these types of operations on the Excel help website.

5

I’d be able to get them all imported into Access no problem.

It’s getting them into Coloums without doing it manually.

Just wondering if there was an easier way that somebody knew and I didn’t thats all.

Thanks anyway

6

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.