Sorrt pasted data into specific columns

Hi,

I was wondering if anyone knew how to sort data pasted from word into specific columns e.g.

I paste: 1,2,3,4,8 into the ref row, and it poulates as such, leaving out the columns for which there is no corresponding value:




Competency: 1------2--------3-------4------5------6------7------8
Ref: -------WR1----WR1----WR1-----------WR5------------------WR1

Any help would be much appreciated

Regards

Hi,

Welcome to the Forum.

Please post a sample templates of Excel & Word files using "Go Advanced" option.

Hi,

I kinda worked it out using a long winded method:

I copied all my data in to a source table,

Then I used a different table and the countif function to populate it with 1 or O depending on whether the column heading matched my data

A third table then looked and populated the 1's with my reference number and 0's with a blank space

Thanks for your interest and help.

Regards