controlling data

EDUCATED MONKEY

Board Regular
Joined
Jul 17, 2011
Messages
218
My os is windows xp professional office xp 2003 ? not 100% on that <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
<o:p></o:p>
Hello thank you to those people that have helped me with the column issue, As I got it a bit mixed up that’s not what I needed and the examples I tried did do as I asked but what I needed to do was move two columns from one sheet from columns F and G and place them in columns A and B underneath the previous entry. So the end result required is two columns A and B with all the data in them <o:p></o:p>
<o:p></o:p>
I would also like to say that I do use the search on the site and now realise the importance of choosing the best title so the others with similar problems can benefit from it and declaring what software you are using, I have asked a good few questions over the last week or so and the replies I have received have been tremendous and I have learned something from each one <o:p></o:p>
<o:p></o:p>
 
Last edited:

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,223,237
Messages
6,170,928
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top