Friday, September 23, 2016

How to Fix Problem - Copy Data Horizontally downwards for 19 Columns?

Copy Data Horizontally downwards for 19 Columns

Dear all,
I have over 5000 of data (some are numeric and some are alphabets) listed vertically, I need a formula that could put the data horizontally for 19 columns each downwards.
For example: I have the below set of vertical data.
 

10630

10634

10740

10752

10753

10759

10761

10763

10802

10813

10822

10846

10847

10857

10867

10940

11054

11062

11073

11118

11141

11177

11181

11194

11258

11562

11592

11625

11629

11634

11712

11733

11899

11902

11932

12056

12153

12187

12197

12199

12240

12302

12305

12402

 
The required is as follows,I am trying to copy the same horizontally for 19 columns each.
 
 

Column 1
Column 2
Column 3
Column 4
Column 5
Column 6
Column 7
Column 8
Column 9
Column 10
Column 11
Column 12
Column 13
Column 14
Column 15
Column 16
Column 17
Column 18
Column 19

10630
10634
10740
10752
10753
10759
10761
10763
10802
10813
10822
10846
10847
10857
10867
10940
11054
11062
11073

11118
11141
11177
11181
11194
11258
11562
11592
11625
11629
11634
11712
11733
11899
11902
11932
12056
12153
12187

12197
12199
12240
12302
12305
12402

 
Please assist..

Keys to the Problem Copy Data Horizontally downwards for 19 Columns

Download Error Fixer for Free Now

Dharmesh,
Say your data is in A1:A6000 of Sheet1, then in A1 of Sheet2 have this formula, and drag fill across to S1 (i.e.
19 columns) and then downwards as far as necessary:
=IFERROR(INDEX(Sheet1!$A$1:$A$6000,COLUMN(A1)+(19*(ROW(A1)-1))),"")
 
___________
Regards, Tom

To check for Windows updates

  1. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
  2. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
  3. If any updates are found, click Install updates. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Recommended Method to Repair the Problem: Copy Data Horizontally downwards for 19 Columns:

How to Fix Copy Data Horizontally downwards for 19 Columns with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your computer. When you open SmartPCFixer, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed


Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Troubleshooter of Error: CONVERT classified pdf to word doc,How Can I Fix - Continuing text past section break?,Troubleshoot:Convert a column of numbers into Alphabet characters Error,Control Panel wont open,Fast Solution to Problem: Converting percentages into whole numbers,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly

No comments:

Post a Comment