Excel中怎么實現(xiàn)動態(tài)行轉(zhuǎn)列

這篇文章將為大家詳細講解有關(guān)Excel中怎么實現(xiàn)動態(tài)行轉(zhuǎn)列，文章內(nèi)容質(zhì)量較高，因此小編分享給大家做個參考，希望大家閱讀完這篇文章后對相關(guān)知識有一定的了解。

成都創(chuàng)新互聯(lián)公司專注于紅崗企業(yè)網(wǎng)站建設(shè),自適應(yīng)網(wǎng)站建設(shè),電子商務(wù)商城網(wǎng)站建設(shè)。紅崗網(wǎng)站建設(shè)公司,為紅崗等地區(qū)提供建站服務(wù)。全流程按需開發(fā)，專業(yè)設(shè)計，全程項目跟蹤，成都創(chuàng)新互聯(lián)公司專業(yè)和態(tài)度為您提供的服務(wù)

查詢的SQL如下

select type,ts,cn,as DECIMAL) val from (
select
starttime,'發(fā)布' type,base.ts,base.cn,ifnull(t1.val,0) val
from
(
select
t1.*,
startdate+ interval id-1 hour starttime,
startdate+ interval id hour endtime,
date_format(startdate+ interval id-1 hour,'%m%d%H') ts,
vars.*
from nums ,(select ${starttime} startdate,${endtime} enddate) vars,
(
select 'mvbox_user.user_otherinfo' busidatatype,1 type,'內(nèi)容審核.個人資料' cn union all
select 'mvbox_user.user_baseinfo',1,'內(nèi)容審核.個人喜好' union all
select 'photo_album',1,'內(nèi)容審核.相冊信息' union all
select 'photo_list',1,'內(nèi)容審核.圖片信息' union all
select 'music_original',1,'內(nèi)容審核.原唱信息' union all
select 'music_cover',1,'內(nèi)容審核.翻唱信息' union all
select 'music_accompany',1,'內(nèi)容審核.伴奏信息' union all
select 'music_album',1,'內(nèi)容審核.音樂專輯' union all
select 'music_video',1,'內(nèi)容審核.視頻信息' union all
select 'blog_album',1,'內(nèi)容審核.日志與文章' union all
select 'mvbox_user.user_baseinfo',2,'內(nèi)容審核.MVBOX頭像審核'
) t1
where id<= TIMESTAMPDIFF(hour,startdate,enddate)
order by busidatatype,type,starttime
) base join
(
select busidatatype,type,date_format(createtime,'%m%d%H') ts,from audit_obj_detail
where createtime>=${starttime} and createtime<${endtime}
and busitype = 'mvbox'
group by busidatatype,type,date_format(createtime,'%m%d%H')
) t1 on (base.busidatatype=t1.busidatatype and base.type=t1.type and base.ts=t1.ts)
group by base.busidatatype,base.type,base.ts,base.cn
union all
select
starttime, '審核' type,base.ts,base.cn,ifnull(t1.val,0) val
from
(
select
t1.*,
startdate+ interval id-1 hour starttime,
startdate+ interval id hour endtime,
date_format(startdate+ interval id-1 hour,'%m%d%H') ts,
vars.*
from nums ,(select ${starttime} startdate,${endtime} enddate) vars,
(
select 'mvbox_user.user_otherinfo' busidatatype,1 type,'內(nèi)容審核.個人資料' cn union all
select 'mvbox_user.user_baseinfo',1,'內(nèi)容審核.個人喜好' union all
select 'photo_album',1,'內(nèi)容審核.相冊信息' union all
select 'photo_list',1,'內(nèi)容審核.圖片信息' union all
select 'music_original',1,'內(nèi)容審核.原唱信息' union all
select 'music_cover',1,'內(nèi)容審核.翻唱信息' union all
select 'music_accompany',1,'內(nèi)容審核.伴奏信息' union all
select 'music_album',1,'內(nèi)容審核.音樂專輯' union all
select 'music_video',1,'內(nèi)容審核.視頻信息' union all
select 'blog_album',1,'內(nèi)容審核.日志與文章' union all
select 'mvbox_user.user_baseinfo',2,'內(nèi)容審核.MVBOX頭像審核'
) t1
where id<= TIMESTAMPDIFF(hour,startdate,enddate)
order by busidatatype,type,starttime
) base join
(
select busidatatype,type,date_format(AuditTime,'%m%d%H') ts,from audit_obj_detail
where AuditTime>=${starttime} and AuditTime<${endtime}
and busitype = 'mvbox'
group by busidatatype,type,date_format(AuditTime,'%m%d%H')
) t1 on (base.busidatatype=t1.busidatatype and base.type=t1.type and base.ts=t1.ts)
group by base.busidatatype,base.type,base.ts,base.cn
) t1 ;