Table column

If you have a suggestion how to improve please let me know. If more users will ask for the feature I will have no choice but to implement it.
Post Reply
sveinboss
Professional
Posts: 54
Joined: Tue Nov 03, 2015 5:53 pm

Table column

Post by sveinboss » Tue May 28, 2019 1:09 pm

Hello

Is it possible to split the table column from total and home/away?
So when export to excel, total come in one column and home in another column

Svein

User avatar
Mihai
Moderator
Posts: 1117
Joined: Tue Oct 20, 2015 11:26 am

Re: Table column

Post by Mihai » Sun Jun 02, 2019 2:04 pm

Sorry for the late response sveinboss, but just to be sure I understood :
You would like to export home/away standings together? Or just number of points home/away? Please give more details
www.cgmbet.com

sveinboss
Professional
Posts: 54
Joined: Tue Nov 03, 2015 5:53 pm

Re: Table column

Post by sveinboss » Sun Jun 02, 2019 6:59 pm

When downloading now the table comes in one cell,
Ex: 2(6) Total is 2 and home is 6. I want 2 to come in one cell and 6 in another.
If I want to find difference I cannot if it comes in the same cell in excel if you know what I mean.
Attachments
exempel.xlsx
(8.7 KiB) Downloaded 8 times

inamoto_
New
Posts: 1
Joined: Tue Dec 25, 2018 12:10 am

Re: Table column

Post by inamoto_ » Fri Jun 07, 2019 3:47 am

You'd probably have to do that in Excel until Mihai comes up with a built in option. :)
Open file in Excel
Insert column between team values
highlight column with goal stats
Select Text to Columns option under Data tab in Excel
Select Delimited option then Next
check the Other radio button
Enter "(" in space provided
Select Next

You have to do a little more cleaning up of the file may with the find and replace option to get it nice and tidy.

Manual but I hope it helps.

User avatar
Mihai
Moderator
Posts: 1117
Joined: Tue Oct 20, 2015 11:26 am

Re: Table column

Post by Mihai » Fri Jun 07, 2019 4:54 am

Thank you inamoto_

Godd to know but just managed last night to make the changes and now the columns will be separated.
I hope is OK. Please report any bug
www.cgmbet.com

sveinboss
Professional
Posts: 54
Joined: Tue Nov 03, 2015 5:53 pm

Re: Table column

Post by sveinboss » Fri Jun 07, 2019 7:17 am

Ok thank you
I tried your solution and that works
Thank you

Svein

User avatar
Mihai
Moderator
Posts: 1117
Joined: Tue Oct 20, 2015 11:26 am

Re: Table column

Post by Mihai » Fri Jun 07, 2019 11:24 am

Did you try to EXPORT now? There should be separate columns. Everything OK?
www.cgmbet.com

sveinboss
Professional
Posts: 54
Joined: Tue Nov 03, 2015 5:53 pm

Re: Table column

Post by sveinboss » Fri Jun 07, 2019 2:23 pm

Yes it works when I download to excel, but problems when I try to save as default
I send you the file

User avatar
Mihai
Moderator
Posts: 1117
Joined: Tue Oct 20, 2015 11:26 am

Re: Table column

Post by Mihai » Fri Jun 07, 2019 4:02 pm

Should be OK now, thank you for reporting
www.cgmbet.com

sveinboss
Professional
Posts: 54
Joined: Tue Nov 03, 2015 5:53 pm

Re: Table column

Post by sveinboss » Fri Jun 07, 2019 4:52 pm

Yes now its working fine....thank you

Svein

Post Reply