Export data into Excel in Transpose Format (1 Viewer)

abdulnaseer

New member
Local time
Today, 13:09
Joined
Jan 30, 2013
Messages
1
Is there any way to transfer data into excel transpose format.

Please find herewith attached zip file for review.
 

Attachments

  • FILES.zip
    19.3 KB · Views: 145

spikepl

Eledittingent Beliped
Local time
Today, 12:09
Joined
Nov 3, 2010
Messages
6,142
  1. You can create a temp table and via VBA put tranposed values there and export that table.
  2. Or you can write the table source(i,j) into destination(j,i) in the exel sheet.
  3. Or you can export the table into Excel, and there record a macro for transposing, and fit that code into your code.
 

Users who are viewing this thread

Top Bottom