Coverting Rows in Fields

[khansab143]

I am trying to import data from MS Access but it comes as rows i
excel.
Is it possible to while we importing the database into the excel
we change the rows to columns and data still get synce with databas
source.

lets say fields a1 b1 c1 d1
data a2 b2 c2 d2

a1 a2
b1 b2
c1 c2
d1 d2


Regards,
A

 

[Ragdyer]

Select all the data (fields and data),
right click and choose "Copy",
Right click in top left cell of new location (*no* overlap),
Choose "Paste Special",
And click "Transpose".

You could also paste to another sheet if necessary.

 

[khansab143]

Thank You,

I am doing for Database when ever new record will enter to the
Access.
i will not show in that situation in the Excel. I already done it. Is
there any other solutions.

Regards
THank again AJ

 

[Ragdyer]

I overlooked the request in your OP to "sync" the data.

Does this work for you?

Say you import to Sheet1.
Try this on Sheet2, where you can enter this formula in any cell:

=INDEX(Sheet1!$A:$AA,COLUMNS($A:A),ROWS($1:1))

Then, copy across, and then copy down.

I've set the index range for 27 columns ( A:AA ),
Which allows you to copy down 27 rows, and across unlimited columns.
If your original data extends beyond Column AA,
just adjust that in the formula.
Of course, the max is 256 rows down if the index range goes to A:IV.