Coverting Rows in Fields

[khansab143]

I am trying to import data from MS Access but it comes as rows in 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 database source.

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

a1 a2
b1 b2
c1 c2
d1 d2


Regards,
AJ

[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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"khansab143" <[email protected]> wrote
in message news:[email protected]...
>
> I am trying to import data from MS Access but it comes as rows in
> 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 database
> source.
>
> lets say fields a1 b1 c1 d1
> data a2 b2 c2 d2
>
> a1 a2
> b1 b2
> c1 c2
> d1 d2
>
>
> Regards,
> AJ
>
>
> --
> khansab143
> ------------------------------------------------------------------------
> khansab143's Profile:
http://www.excelforum.com/member.php...o&userid=36409
> View this thread: http://www.excelforum.com/showthread...hreadid=561832
>

[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.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"khansab143" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> khansab143
> ------------------------------------------------------------------------
> khansab143's Profile:
http://www.excelforum.com/member.php...o&userid=36409
> View this thread: http://www.excelforum.com/showthread...hreadid=561832
>