Home » Forums » Open Source Learning Center » Question and Answer

Need Help Arranging the Fields and respective data in an order.

Submitted by toughguy_trains on 11 December, 2013 - 06:20

Hi,

Please can any one help on how to Arrange the Fields and respective data in an order. using formula or script.
I have attached the example file with this post.

AttachmentSize
New Microsoft Office Excel Worksheet.xlsx8.51 KB
‹ How to extract data from XML file on Excel . Help needed ›
»

Arrange And Order Fields

Submitted by DavidGonzalesMetrics on 19 January, 2014 - 20:44.

Hi,

I have written 120 lines of VBA code to delete blank columns and move each data column up so the headers are on row 1. That's alot of code to paste into a comment section. Is there another way to make the code available?

Regards,
David

»

Just had a look at this one

Submitted by mec1981 on 12 January, 2014 - 05:18.

Just had a look at this one for you and now understand why there has been no reply. Your example spreadsheet has nothing but headers on it placed sporadically across the spreadsheet.
You have not identified what column/heading you wish it sorted by or even in what manner you wish the data sorted.

Is there any reason why you can't have all the headers on the same row i.e. Row A and just use the sort or Auto Filter functions in built to excel?

»