How can I take rows of data and insert two lines between them. See example below:
Looks like this:
A B
1 234 at
2 342 be
3 125 ant
4 782 deal
5 572 field
Needs to look like this:
A B
1 234 at
2
3
4 342 be
5
6
7...
Thanks swtrader. I wanted it in Access too(actually I already have most of it imported) but the person I am creating this for is dead set on it being in Excel even though I have stressed to her how much easier it would be in Access. Thanks again for taking time to respond.
CAN SOMEONE HELP ME CREATE A FORM IN EXCEL XP. I HAVE A SPREADSHEET THAT HAS A TEAM NAME, DEPOSIT AMOUNT (10 DIFFERENT COLUMNS FOR INDIVIDUAL DEPOSITS), DEPOSIT DATE (10 COLUMNS TO MATCH UP WITH THE DEPOSITS), DEPOSITED TO (10 COLUMNS TO MATCH WITH DEPOSITS, DEPOSIT DATE),REG FEE (1 COLUMN)...
The charts are in the same workbook just on different sheets. The data is on one worksheet. We created 4 charts from the data sheet. I tried what Anna2222 suggested but it still didn't work.
Everytime I open Excel, every cell on every page(workbook) is dividing what ever number or character I put in there by 100. I have tried formatting it and that doesn't work. Any suggestions?
Is there a way to display more than 1,024 characters(ie...they want to print this document out and they want all the text to show...the largest cell has approx 2500 text characters).
Is there a max width the column can be in excel. I have a worksheet and it has a column width of 69.71 and will not open anymore unless I double click....the row height is 165.75. There is more text in the field but if you widen it then close the worksheet when you open it back up you can not...
Why would a text file export from diskette into Access ok but when you try to export it from Access to Excel the data will not all export. You can break it into sections and export but can't send it as one export. The field sizes are not large. How can you tell if the data on the disk is...
No the account number in the Vendor Info is the account number on the bill. These are for telecommunication bills that are received monthly. The account number in the Account number is for company charge back (the account number each area gives me to report to A/P). The reason for the joins...
Vendor Name and Phone Number. I have checked to make sure that both have the same exact setting on each table and they do. (ie: format, data type...etc)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.