https://capipedia.cap.gov/index.php?title=Create_a_Table&feed=atom&action=historyCreate a Table - Revision history2024-03-28T20:03:49ZRevision history for this page on the wikiMediaWiki 1.41.0https://capipedia.cap.gov/index.php?title=Create_a_Table&diff=413&oldid=prevDavidDlugiewicz: Created page with "== To Create a Table == Easiest to use Excel Add columns between your data In row 1, column 1 put a | Copy down to last row In row 1, column 3 put a || Copy down to last row I..."2020-05-08T10:39:40Z<p>Created page with "== To Create a Table == Easiest to use Excel Add columns between your data In row 1, column 1 put a | Copy down to last row In row 1, column 3 put a || Copy down to last row I..."</p>
<p><b>New page</b></p><div>== To Create a Table ==<br />
Easiest to use Excel<br />
Add columns between your data<br />
In row 1, column 1 put a |<br />
Copy down to last row<br />
In row 1, column 3 put a ||<br />
Copy down to last row<br />
In row 1, column 5 put a || Repeat for all blank columns<br />
Copy down for all columns<br />
Add a 2 columns before 1<br />
put 1 in row 1 column 1<br />
Highlight and select a series add 1<br />
Copy from 1 to the end<br />
past after last row<br />
on the first blank row with 1<br />
add |-<br />
Copy to end<br />
Sort columns on the number field<br />
Delete the numbers column<br />
Fix header ! Header text !! Header text !! Header text<br />
Save as CSV<br />
open in text editor<br />
remove all ,<br />
Copy text and paste at header line<br />
<br />
In CAPipedia add a Sortable Table<br />
<br />
<br />
{| class="wikitable sortable"<br />
|-<br />
! Header text !! Header text !! Header text<br />
|-<br />
| Example || Example || Example<br />
|-<br />
| Example || Example || Example<br />
|-<br />
| Example || Example || Example<br />
|}</div>DavidDlugiewicz