Macro to Automate Transpose column to rows Excel 2010

I have worked with Excel a lot but have never used Macros and I do not know much about Programming

I get .txt files with 2 columns of info
Column A info keeps track of column B data
Column A data '00' = start of a new record (shows in A1, A36, A71, etc)
Column B is data that needs to TRANSPOSE
There is always some rows that are blank, and need to be blank after TRANSPOSE


Every 35 Rows of Column B equals one record
this needs to TRANSPOSE to 1 row with 35 columns, starting at C2 or on a new sheet at A2

the total data in Column B may very each time from 175 rows to 70,000 rows.
After TRANSPOSE, the result would be 5 rows to 2000 rows

Please Login or Register  to view this content.